﻿CREATE TABLE [dbo].[Vendor] (
    [Id]          INT           IDENTITY (1, 1) NOT NULL,
    [CompanyName] VARCHAR (100) NOT NULL,
    [Address]     VARCHAR (200) NULL,
    [City]        VARCHAR (200) NULL,
    [State]       VARCHAR (200) NULL,
    [ZipCode]     VARCHAR (200) NULL,
    [Country]     VARCHAR (50)  NULL,
    [EMail]       VARCHAR (100) NULL,
    [Attn]        VARCHAR (100) NULL,
    [Phone]       VARCHAR (50)  NULL,
    PRIMARY KEY CLUSTERED ([Id] ASC)
);


